<?php


namespace App\Http\Controllers\Admin;

use Illuminate\Http\Request;

use App\Http\Requests;
use App\Http\Controllers\Controller;
use App\Model\Cat;
use DB;
class CatController extends Controller
{
    protected  $Cat;//catModel


    public  function  __construct()
    {
        $this->Cat = new Cat();

    }

    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     *
     */
    public function index()
    {

        $cats = $this->Cat->findAll();


        return view('admin.catIndex')->with('cats',$cats);
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        $cats = $this->Cat->findAll();
        return view('admin.catAdd')->with('cats',$cats);

       
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {

        //dd($request->all());
       //验证
        $cat = $this->Cat;
        $cat->parent_id=$request->parent_id;
        $cat->cat_name = $request->cat_name;
        $cat->save();
        return redirect('/cat');
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
         $res = DB::table('cats')->where('cat_id',$id)->delete();

         return redirect('/cat');
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
       
        $cats = $this->Cat->All();
        $cat = DB::table('cats')->where('cat_id',$id)->first();

        return view('admin.catEdit')->with('cat',$cat)->with('cats',$cats);

    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        $name = $request->cat_name;
        $pid = $request->parent_id;
        DB::table('cats')
            ->where('cat_id',$id )
            ->update(['cat_name' => $name,'parent_id' => $pid]);
        return redirect('/cat');
        
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        
        // //dd($id);
        // \DB::table("cats")->where("cat_id",$id)->delete();
        // return redirect('/cat');
                 
    }




    public function  asd()
    {

        $id=$_POST['asd'];
        $cats = DB::table("cats")->where('parent_id',$id)->get();
        foreach($cats as $cat){
            $var[]=$cat->cat_name;
        }
        return $var;
    } 



}
